Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 1325100 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 204.1 MiB |
| Average record size in memory | 161.5 B |
Variable types
| Categorical | 4 |
|---|---|
| DateTime | 1 |
| Numeric | 11 |
cusip_id has a high cardinality: 1893 distinct values | High cardinality |
bond_sym_id has a high cardinality: 1981 distinct values | High cardinality |
company_symbol has a high cardinality: 520 distinct values | High cardinality |
rptd_pr is highly overall correlated with yld_pt | High correlation |
yld_pt is highly overall correlated with rptd_pr | High correlation |
offering_yield is highly overall correlated with coupon | High correlation |
coupon is highly overall correlated with offering_yield | High correlation |
offering_month is highly overall correlated with maturity_month | High correlation |
maturity_month is highly overall correlated with offering_month | High correlation |
principal_amt is highly imbalanced (98.5%) | Imbalance |
yld_pt is highly skewed (γ1 = 175.5750013) | Skewed |
offering_yield is highly skewed (γ1 = 43.47418549) | Skewed |
cusip_id is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2023-08-10 18:42:53.548349 |
|---|---|
| Analysis finished | 2023-08-10 18:43:36.685457 |
| Duration | 43.14 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
cusip_id
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 1893 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.2 MiB |
| 00037BAB8 | 700 |
|---|---|
| 65339KBM1 | 700 |
| 655844BJ6 | 700 |
| 655664AT7 | 700 |
| 655664AS9 | 700 |
| Other values (1888) |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 11925900 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 00037BAB8 |
|---|---|
| 2nd row | 00037BAB8 |
| 3rd row | 00037BAB8 |
| 4th row | 00037BAB8 |
| 5th row | 00037BAB8 |
Common Values
| Value | Count | Frequency (%) |
| 00037BAB8 | 700 | 0.1% |
| 65339KBM1 | 700 | 0.1% |
| 655844BJ6 | 700 | 0.1% |
| 655664AT7 | 700 | 0.1% |
| 655664AS9 | 700 | 0.1% |
| 65504LAP2 | 700 | 0.1% |
| 65504LAN7 | 700 | 0.1% |
| 655044AP0 | 700 | 0.1% |
| 655044AH8 | 700 | 0.1% |
| 654902AE5 | 700 | 0.1% |
| Other values (1883) | 1318100 |
Length
| Value | Count | Frequency (%) |
| 00037bab8 | 700 | 0.1% |
| 00206rcl4 | 700 | 0.1% |
| 001055ap7 | 700 | 0.1% |
| 001055aq5 | 700 | 0.1% |
| 001546at7 | 700 | 0.1% |
| 00164vac7 | 700 | 0.1% |
| 00164vae3 | 700 | 0.1% |
| 00185aad6 | 700 | 0.1% |
| 00185aaf1 | 700 | 0.1% |
| 00185aak0 | 700 | 0.1% |
| Other values (1883) | 1318100 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1026900 | 8.6% |
| 2 | 940800 | 7.9% |
| 7 | 891100 | 7.5% |
| 4 | 889000 | 7.5% |
| 6 | 870100 | 7.3% |
| 3 | 866600 | 7.3% |
| 1 | 864500 | 7.2% |
| 5 | 856800 | 7.2% |
| A | 845600 | 7.1% |
| 8 | 833700 | 7.0% |
| Other values (24) | 3040800 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 8731100 | |
| Uppercase Letter | 3194800 | 26.8% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 845600 | |
| B | 355600 | 11.1% |
| C | 208600 | 6.5% |
| D | 151200 | 4.7% |
| E | 112700 | 3.5% |
| H | 103600 | 3.2% |
| F | 100100 | 3.1% |
| N | 100100 | 3.1% |
| X | 98000 | 3.1% |
| J | 97300 | 3.0% |
| Other values (14) | 1022000 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1026900 | |
| 2 | 940800 | |
| 7 | 891100 | |
| 4 | 889000 | |
| 6 | 870100 | |
| 3 | 866600 | |
| 1 | 864500 | |
| 5 | 856800 | |
| 8 | 833700 | |
| 9 | 691600 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 8731100 | |
| Latin | 3194800 | 26.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 845600 | |
| B | 355600 | 11.1% |
| C | 208600 | 6.5% |
| D | 151200 | 4.7% |
| E | 112700 | 3.5% |
| H | 103600 | 3.2% |
| F | 100100 | 3.1% |
| N | 100100 | 3.1% |
| X | 98000 | 3.1% |
| J | 97300 | 3.0% |
| Other values (14) | 1022000 |
Common
| Value | Count | Frequency (%) |
| 0 | 1026900 | |
| 2 | 940800 | |
| 7 | 891100 | |
| 4 | 889000 | |
| 6 | 870100 | |
| 3 | 866600 | |
| 1 | 864500 | |
| 5 | 856800 | |
| 8 | 833700 | |
| 9 | 691600 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11925900 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1026900 | 8.6% |
| 2 | 940800 | 7.9% |
| 7 | 891100 | 7.5% |
| 4 | 889000 | 7.5% |
| 6 | 870100 | 7.3% |
| 3 | 866600 | 7.3% |
| 1 | 864500 | 7.2% |
| 5 | 856800 | 7.2% |
| A | 845600 | 7.1% |
| 8 | 833700 | 7.0% |
| Other values (24) | 3040800 |
trd_exctn_dt
Date
| Distinct | 1577 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.2 MiB |
| Minimum | 2017-01-04 00:00:00 |
|---|---|
| Maximum | 2022-09-01 00:00:00 |
bond_sym_id
Categorical
| Distinct | 1981 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.2 MiB |
| ABB3852125 | 700 |
|---|---|
| MUR3856177 | 700 |
| NWL3865872 | 700 |
| NTAP4547207 | 700 |
| NTAP4131791 | 700 |
| Other values (1976) |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 9.9765542 |
| Min length | 8 |
Characters and Unicode
| Total characters | 13219932 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ABB3852125 |
|---|---|
| 2nd row | ABB3852125 |
| 3rd row | ABB3852125 |
| 4th row | ABB3852125 |
| 5th row | ABB3852125 |
Common Values
| Value | Count | Frequency (%) |
| ABB3852125 | 700 | 0.1% |
| MUR3856177 | 700 | 0.1% |
| NWL3865872 | 700 | 0.1% |
| NTAP4547207 | 700 | 0.1% |
| NTAP4131791 | 700 | 0.1% |
| NTAP3940743 | 700 | 0.1% |
| CMCS3910950 | 700 | 0.1% |
| NFG4543079 | 700 | 0.1% |
| MYL4072753 | 700 | 0.1% |
| MUR4880676 | 700 | 0.1% |
| Other values (1971) | 1318100 |
Length
| Value | Count | Frequency (%) |
| abb3852125 | 700 | 0.1% |
| are4459169 | 700 | 0.1% |
| acc4136081 | 700 | 0.1% |
| aep4563780 | 700 | 0.1% |
| aep4773531 | 700 | 0.1% |
| ael4507378 | 700 | 0.1% |
| axp4633129 | 700 | 0.1% |
| axp4662255 | 700 | 0.1% |
| axp4764026 | 700 | 0.1% |
| axp4764027 | 700 | 0.1% |
| Other values (1971) | 1318100 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 2066400 | |
| 3 | 993300 | 7.5% |
| 8 | 844200 | 6.4% |
| 6 | 840000 | 6.4% |
| 0 | 786800 | 6.0% |
| 2 | 778400 | 5.9% |
| 5 | 768600 | 5.8% |
| 1 | 758800 | 5.7% |
| 9 | 755300 | 5.7% |
| 7 | 683900 | 5.2% |
| Other values (26) | 3944232 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 9275700 | |
| Uppercase Letter | 3944232 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 321354 | 8.1% |
| A | 303906 | 7.7% |
| M | 284451 | 7.2% |
| S | 259563 | 6.6% |
| P | 234284 | 5.9% |
| B | 213910 | 5.4% |
| T | 213324 | 5.4% |
| L | 198984 | 5.0% |
| N | 175470 | 4.4% |
| E | 163368 | 4.1% |
| Other values (16) | 1575618 |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 2066400 | |
| 3 | 993300 | |
| 8 | 844200 | |
| 6 | 840000 | |
| 0 | 786800 | 8.5% |
| 2 | 778400 | 8.4% |
| 5 | 768600 | 8.3% |
| 1 | 758800 | 8.2% |
| 9 | 755300 | 8.1% |
| 7 | 683900 | 7.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 9275700 | |
| Latin | 3944232 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 321354 | 8.1% |
| A | 303906 | 7.7% |
| M | 284451 | 7.2% |
| S | 259563 | 6.6% |
| P | 234284 | 5.9% |
| B | 213910 | 5.4% |
| T | 213324 | 5.4% |
| L | 198984 | 5.0% |
| N | 175470 | 4.4% |
| E | 163368 | 4.1% |
| Other values (16) | 1575618 |
Common
| Value | Count | Frequency (%) |
| 4 | 2066400 | |
| 3 | 993300 | |
| 8 | 844200 | |
| 6 | 840000 | |
| 0 | 786800 | 8.5% |
| 2 | 778400 | 8.4% |
| 5 | 768600 | 8.3% |
| 1 | 758800 | 8.2% |
| 9 | 755300 | 8.1% |
| 7 | 683900 | 7.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 13219932 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4 | 2066400 | |
| 3 | 993300 | 7.5% |
| 8 | 844200 | 6.4% |
| 6 | 840000 | 6.4% |
| 0 | 786800 | 6.0% |
| 2 | 778400 | 5.9% |
| 5 | 768600 | 5.8% |
| 1 | 758800 | 5.7% |
| 9 | 755300 | 5.7% |
| 7 | 683900 | 5.2% |
| Other values (26) | 3944232 |
company_symbol
Categorical
| Distinct | 520 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.2 MiB |
| AAPL | 18900 |
|---|---|
| C | 16100 |
| CMCS | 16100 |
| GM | 16100 |
| DUK | 14700 |
| Other values (515) |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 2.9765542 |
| Min length | 1 |
Characters and Unicode
| Total characters | 3944232 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ABB |
|---|---|
| 2nd row | ABB |
| 3rd row | ABB |
| 4th row | ABB |
| 5th row | ABB |
Common Values
| Value | Count | Frequency (%) |
| AAPL | 18900 | 1.4% |
| C | 16100 | 1.2% |
| CMCS | 16100 | 1.2% |
| GM | 16100 | 1.2% |
| DUK | 14700 | 1.1% |
| BA | 14700 | 1.1% |
| BP | 14000 | 1.1% |
| CVS | 14000 | 1.1% |
| F | 12600 | 1.0% |
| UNH | 12600 | 1.0% |
| Other values (510) | 1175300 |
Length
| Value | Count | Frequency (%) |
| aapl | 18900 | 1.4% |
| c | 16100 | 1.2% |
| cmcs | 16100 | 1.2% |
| gm | 16100 | 1.2% |
| duk | 14700 | 1.1% |
| ba | 14700 | 1.1% |
| bp | 14000 | 1.1% |
| cvs | 14000 | 1.1% |
| f | 12600 | 1.0% |
| unh | 12600 | 1.0% |
| Other values (510) | 1175300 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 321354 | 8.1% |
| A | 303906 | 7.7% |
| M | 284451 | 7.2% |
| S | 259563 | 6.6% |
| P | 234284 | 5.9% |
| B | 213910 | 5.4% |
| T | 213324 | 5.4% |
| L | 198984 | 5.0% |
| N | 175470 | 4.4% |
| E | 163368 | 4.1% |
| Other values (16) | 1575618 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3944232 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 321354 | 8.1% |
| A | 303906 | 7.7% |
| M | 284451 | 7.2% |
| S | 259563 | 6.6% |
| P | 234284 | 5.9% |
| B | 213910 | 5.4% |
| T | 213324 | 5.4% |
| L | 198984 | 5.0% |
| N | 175470 | 4.4% |
| E | 163368 | 4.1% |
| Other values (16) | 1575618 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3944232 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 321354 | 8.1% |
| A | 303906 | 7.7% |
| M | 284451 | 7.2% |
| S | 259563 | 6.6% |
| P | 234284 | 5.9% |
| B | 213910 | 5.4% |
| T | 213324 | 5.4% |
| L | 198984 | 5.0% |
| N | 175470 | 4.4% |
| E | 163368 | 4.1% |
| Other values (16) | 1575618 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3944232 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 321354 | 8.1% |
| A | 303906 | 7.7% |
| M | 284451 | 7.2% |
| S | 259563 | 6.6% |
| P | 234284 | 5.9% |
| B | 213910 | 5.4% |
| T | 213324 | 5.4% |
| L | 198984 | 5.0% |
| N | 175470 | 4.4% |
| E | 163368 | 4.1% |
| Other values (16) | 1575618 |
entrd_vol_qt
Real number (ℝ)
| Distinct | 18633 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1356446.6 |
| Minimum | 1 |
|---|---|
| Maximum | 5.83931 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10000 |
| Q1 | 54000 |
| median | 270000 |
| Q3 | 1011000 |
| 95-th percentile | 6000000 |
| Maximum | 5.83931 × 108 |
| Range | 5.83931 × 108 |
| Interquartile range (IQR) | 957000 |
Descriptive statistics
| Standard deviation | 3515981.9 |
|---|---|
| Coefficient of variation (CV) | 2.5920532 |
| Kurtosis | 799.35082 |
| Mean | 1356446.6 |
| Median Absolute Deviation (MAD) | 245000 |
| Skewness | 13.065426 |
| Sum | 1.7974275 × 1012 |
| Variance | 1.2362129 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100000 | 55837 | 4.2% |
| 500000 | 55613 | 4.2% |
| 1000000 | 51678 | 3.9% |
| 50000 | 47090 | 3.6% |
| 200000 | 39602 | 3.0% |
| 25000 | 37691 | 2.8% |
| 10000 | 33883 | 2.6% |
| 2000000 | 30062 | 2.3% |
| 250000 | 29652 | 2.2% |
| 20000 | 24642 | 1.9% |
| Other values (18623) | 919350 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 500 | 2 | < 0.1% |
| 1000 | 1022 | 0.1% |
| 2000 | 8291 | |
| 2286 | 1 | < 0.1% |
| 3000 | 7352 | 0.6% |
| 4000 | 6258 | 0.5% |
| 5000 | 18526 | |
| 6000 | 5729 | 0.4% |
| 7000 | 4736 | 0.4% |
| Value | Count | Frequency (%) |
| 583931000 | 1 | |
| 265568000 | 1 | |
| 237000000 | 1 | |
| 223650000 | 1 | |
| 201825000 | 1 | |
| 201139000 | 1 | |
| 193200000 | 1 | |
| 182000000 | 1 | |
| 176695000 | 1 | |
| 173500000 | 1 |
rptd_pr
Real number (ℝ)
| Distinct | 126514 |
|---|---|
| Distinct (%) | 9.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 104.32245 |
| Minimum | 1 × 10-6 |
|---|---|
| Maximum | 142.646 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.2 MiB |
Quantile statistics
| Minimum | 1 × 10-6 |
|---|---|
| 5-th percentile | 95.576 |
| Q1 | 100.425 |
| median | 103.715 |
| Q3 | 108.304 |
| 95-th percentile | 115.24705 |
| Maximum | 142.646 |
| Range | 142.646 |
| Interquartile range (IQR) | 7.879 |
Descriptive statistics
| Standard deviation | 7.116482 |
|---|---|
| Coefficient of variation (CV) | 0.068216205 |
| Kurtosis | 15.901142 |
| Mean | 104.32245 |
| Median Absolute Deviation (MAD) | 3.708 |
| Skewness | -1.3255251 |
| Sum | 1.3823768 × 108 |
| Variance | 50.644316 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 1721 | 0.1% |
| 101 | 1188 | 0.1% |
| 102 | 1065 | 0.1% |
| 100.5 | 994 | 0.1% |
| 101.5 | 970 | 0.1% |
| 99 | 954 | 0.1% |
| 103 | 912 | 0.1% |
| 99.5 | 901 | 0.1% |
| 104 | 894 | 0.1% |
| 101.25 | 892 | 0.1% |
| Other values (126504) | 1314609 |
| Value | Count | Frequency (%) |
| 1 × 10-6 | 1 | < 0.1% |
| 0.625 | 1 | < 0.1% |
| 1 | 4 | |
| 1.1 | 1 | < 0.1% |
| 1.125 | 1 | < 0.1% |
| 1.151 | 1 | < 0.1% |
| 1.188 | 1 | < 0.1% |
| 1.25 | 1 | < 0.1% |
| 1.375 | 1 | < 0.1% |
| 1.47 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 142.646 | 1 | |
| 142.29 | 1 | |
| 142.275 | 1 | |
| 142.044 | 1 | |
| 141.998 | 1 | |
| 141.897 | 1 | |
| 141.846 | 1 | |
| 141.813 | 1 | |
| 141.79 | 1 | |
| 141.75 | 1 |
yld_pt
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 1100043 |
|---|---|
| Distinct (%) | 83.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.5137435 |
| Minimum | 0 |
|---|---|
| Maximum | 2292.1058 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.2 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.36041385 |
| Q1 | 1.2484038 |
| median | 2.2548945 |
| Q3 | 3.3019775 |
| 95-th percentile | 5.014431 |
| Maximum | 2292.1058 |
| Range | 2292.1058 |
| Interquartile range (IQR) | 2.0535737 |
Descriptive statistics
| Standard deviation | 4.2567184 |
|---|---|
| Coefficient of variation (CV) | 1.6933782 |
| Kurtosis | 71345.963 |
| Mean | 2.5137435 |
| Median Absolute Deviation (MAD) | 1.027356 |
| Skewness | 175.575 |
| Sum | 3330961.5 |
| Variance | 18.119652 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.25 | 14 | < 0.1% |
| 3 | 13 | < 0.1% |
| 0.15 | 11 | < 0.1% |
| 0.100001 | 10 | < 0.1% |
| 0.2 | 9 | < 0.1% |
| 0.953921 | 8 | < 0.1% |
| 0.6 | 8 | < 0.1% |
| 1.862988 | 8 | < 0.1% |
| 0.23 | 7 | < 0.1% |
| 2.332995 | 7 | < 0.1% |
| Other values (1100033) | 1325005 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 0.000295 | 1 | |
| 0.000297 | 1 | |
| 0.000306 | 1 | |
| 0.000394 | 1 | |
| 0.000407 | 1 | |
| 0.000516 | 1 | |
| 0.000724 | 1 | |
| 0.000779 | 1 | |
| 0.000798 | 1 |
| Value | Count | Frequency (%) |
| 2292.105824 | 1 | |
| 1103.000191 | 1 | |
| 786.91838 | 1 | |
| 686.986965 | 1 | |
| 653.930338 | 1 | |
| 602.287567 | 1 | |
| 586.555133 | 1 | |
| 537.639051 | 1 | |
| 530.554969 | 1 | |
| 511.780674 | 1 |
offering_amt
Real number (ℝ)
| Distinct | 73 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 987463.81 |
| Minimum | 225000 |
|---|---|
| Maximum | 11000000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.2 MiB |
Quantile statistics
| Minimum | 225000 |
|---|---|
| 5-th percentile | 300000 |
| Q1 | 500000 |
| median | 750000 |
| Q3 | 1250000 |
| 95-th percentile | 2250000 |
| Maximum | 11000000 |
| Range | 10775000 |
| Interquartile range (IQR) | 750000 |
Descriptive statistics
| Standard deviation | 782226.15 |
|---|---|
| Coefficient of variation (CV) | 0.79215678 |
| Kurtosis | 40.546021 |
| Mean | 987463.81 |
| Median Absolute Deviation (MAD) | 250000 |
| Skewness | 4.5932382 |
| Sum | 1.3084883 × 1012 |
| Variance | 6.1187775 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 500000 | 188300 | |
| 1000000 | 184100 | |
| 750000 | 147000 | 11.1% |
| 1500000 | 84000 | 6.3% |
| 1250000 | 81900 | 6.2% |
| 600000 | 74200 | 5.6% |
| 400000 | 65800 | 5.0% |
| 300000 | 46900 | 3.5% |
| 700000 | 42000 | 3.2% |
| 2000000 | 40600 | 3.1% |
| Other values (63) | 370300 |
| Value | Count | Frequency (%) |
| 225000 | 700 | 0.1% |
| 250000 | 19600 | 1.5% |
| 275000 | 2800 | 0.2% |
| 300000 | 46900 | |
| 325000 | 1400 | 0.1% |
| 350000 | 37800 | |
| 375000 | 2100 | 0.2% |
| 380000 | 700 | 0.1% |
| 400000 | 65800 | |
| 420000 | 700 | 0.1% |
| Value | Count | Frequency (%) |
| 11000000 | 1400 | |
| 9000000 | 700 | 0.1% |
| 7500000 | 700 | 0.1% |
| 6000000 | 2100 | |
| 5500000 | 700 | 0.1% |
| 5000000 | 2100 | |
| 4250000 | 1400 | |
| 4000000 | 2800 | |
| 3750000 | 700 | 0.1% |
| 3500000 | 2100 |
offering_price
Real number (ℝ)
| Distinct | 748 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 99.684888 |
| Minimum | 95.273 |
|---|---|
| Maximum | 106.94884 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.2 MiB |
Quantile statistics
| Minimum | 95.273 |
|---|---|
| 5-th percentile | 98.954 |
| Q1 | 99.59 |
| median | 99.808 |
| Q3 | 99.937 |
| 95-th percentile | 100 |
| Maximum | 106.94884 |
| Range | 11.67584 |
| Interquartile range (IQR) | 0.347 |
Descriptive statistics
| Standard deviation | 0.43945333 |
|---|---|
| Coefficient of variation (CV) | 0.0044084248 |
| Kurtosis | 55.129404 |
| Mean | 99.684888 |
| Median Absolute Deviation (MAD) | 0.155 |
| Skewness | -0.36003979 |
| Sum | 1.3209245 × 108 |
| Variance | 0.19311923 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 158900 | 12.0% |
| 99.975 | 7700 | 0.6% |
| 99.992 | 7000 | 0.5% |
| 99.888 | 6300 | 0.5% |
| 99.83 | 6300 | 0.5% |
| 99.819 | 6300 | 0.5% |
| 99.899 | 5600 | 0.4% |
| 99.861 | 5600 | 0.4% |
| 99.983 | 5600 | 0.4% |
| 99.957 | 5600 | 0.4% |
| Other values (738) | 1110200 |
| Value | Count | Frequency (%) |
| 95.273 | 700 | |
| 95.291 | 700 | |
| 95.83 | 700 | |
| 97.052 | 700 | |
| 97.541 | 700 | |
| 97.589 | 700 | |
| 97.636 | 700 | |
| 97.698 | 700 | |
| 97.818 | 700 | |
| 97.831 | 700 |
| Value | Count | Frequency (%) |
| 106.94884 | 700 | 0.1% |
| 100.63342 | 700 | 0.1% |
| 100.5 | 700 | 0.1% |
| 100 | 158900 | |
| 99.999 | 1400 | 0.1% |
| 99.998 | 1400 | 0.1% |
| 99.997 | 2800 | 0.2% |
| 99.996 | 700 | 0.1% |
| 99.995 | 4200 | 0.3% |
| 99.994 | 4200 | 0.3% |
offering_yield
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 1765 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 928.11627 |
| Minimum | 1.57296 |
|---|---|
| Maximum | 1750000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.2 MiB |
Quantile statistics
| Minimum | 1.57296 |
|---|---|
| 5-th percentile | 2.26303 |
| Q1 | 2.98399 |
| median | 3.563 |
| Q3 | 4.17621 |
| 95-th percentile | 5.4 |
| Maximum | 1750000 |
| Range | 1749998.4 |
| Interquartile range (IQR) | 1.19222 |
Descriptive statistics
| Standard deviation | 40211.221 |
|---|---|
| Coefficient of variation (CV) | 43.325629 |
| Kurtosis | 1888.0077 |
| Mean | 928.11627 |
| Median Absolute Deviation (MAD) | 0.588 |
| Skewness | 43.474185 |
| Sum | 1.2298469 × 109 |
| Variance | 1.6169423 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5.375 | 6300 | 0.5% |
| 5.25 | 6300 | 0.5% |
| 5 | 4900 | 0.4% |
| 5.625 | 4900 | 0.4% |
| 5.125 | 4900 | 0.4% |
| 6.125 | 4200 | 0.3% |
| 4.75 | 4200 | 0.3% |
| 5.75 | 3500 | 0.3% |
| 5.875 | 3500 | 0.3% |
| 4.375 | 2100 | 0.2% |
| Other values (1755) | 1280300 |
| Value | Count | Frequency (%) |
| 1.57296 | 700 | |
| 1.57902 | 700 | |
| 1.64392 | 700 | |
| 1.65 | 700 | |
| 1.695 | 700 | |
| 1.70503 | 700 | |
| 1.72201 | 700 | |
| 1.724 | 700 | |
| 1.728 | 700 | |
| 1.73404 | 700 |
| Value | Count | Frequency (%) |
| 1750000 | 700 | 0.1% |
| 9 | 700 | 0.1% |
| 8.62493 | 700 | 0.1% |
| 8.125 | 700 | 0.1% |
| 7.75 | 1400 | |
| 7.7494 | 700 | 0.1% |
| 7.625 | 2100 | |
| 7.5 | 2100 | |
| 7.375 | 1400 | |
| 7.25 | 700 | 0.1% |
principal_amt
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 20.2 MiB |
| 1000.0 | |
|---|---|
| 200000.0 | 2100 |
| 0.0 | 700 |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 6.0015848 |
| Min length | 3 |
Characters and Unicode
| Total characters | 7952700 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1000.0 |
|---|---|
| 2nd row | 1000.0 |
| 3rd row | 1000.0 |
| 4th row | 1000.0 |
| 5th row | 1000.0 |
Common Values
| Value | Count | Frequency (%) |
| 1000.0 | 1322300 | |
| 200000.0 | 2100 | 0.2% |
| 0.0 | 700 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1000.0 | 1322300 | |
| 200000.0 | 2100 | 0.2% |
| 0.0 | 700 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5303200 | |
| . | 1325100 | 16.7% |
| 1 | 1322300 | 16.6% |
| 2 | 2100 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 6627600 | |
| Other Punctuation | 1325100 | 16.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 5303200 | |
| 1 | 1322300 | 20.0% |
| 2 | 2100 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1325100 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7952700 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 5303200 | |
| . | 1325100 | 16.7% |
| 1 | 1322300 | 16.6% |
| 2 | 2100 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7952700 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 5303200 | |
| . | 1325100 | 16.7% |
| 1 | 1322300 | 16.6% |
| 2 | 2100 | < 0.1% |
coupon
Real number (ℝ)
| Distinct | 247 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.6221865 |
| Minimum | 1.55 |
|---|---|
| Maximum | 8.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.2 MiB |
Quantile statistics
| Minimum | 1.55 |
|---|---|
| 5-th percentile | 2.25 |
| Q1 | 2.95 |
| median | 3.5 |
| Q3 | 4.125 |
| 95-th percentile | 5.375 |
| Maximum | 8.75 |
| Range | 7.2 |
| Interquartile range (IQR) | 1.175 |
Descriptive statistics
| Standard deviation | 0.99403283 |
|---|---|
| Coefficient of variation (CV) | 0.27442895 |
| Kurtosis | 2.2077077 |
| Mean | 3.6221865 |
| Median Absolute Deviation (MAD) | 0.6 |
| Skewness | 1.0279602 |
| Sum | 4799759.3 |
| Variance | 0.98810127 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.5 | 55300 | 4.2% |
| 4 | 43400 | 3.3% |
| 3.25 | 38500 | 2.9% |
| 3 | 32200 | 2.4% |
| 3.75 | 32200 | 2.4% |
| 3.375 | 30100 | 2.3% |
| 3.2 | 28000 | 2.1% |
| 3.8 | 27300 | 2.1% |
| 2.75 | 26600 | 2.0% |
| 3.4 | 25900 | 2.0% |
| Other values (237) | 985600 |
| Value | Count | Frequency (%) |
| 1.55 | 1400 | 0.1% |
| 1.625 | 1400 | 0.1% |
| 1.65 | 700 | 0.1% |
| 1.7 | 4900 | |
| 1.75 | 1400 | 0.1% |
| 1.8 | 2800 | |
| 1.85 | 4900 | |
| 1.875 | 3500 | |
| 1.9 | 2100 | |
| 1.902 | 700 | 0.1% |
| Value | Count | Frequency (%) |
| 8.75 | 700 | 0.1% |
| 8.375 | 700 | 0.1% |
| 7.95 | 700 | 0.1% |
| 7.75 | 1400 | 0.1% |
| 7.625 | 2100 | |
| 7.5 | 3500 | |
| 7.375 | 2100 | |
| 7.25 | 700 | 0.1% |
| 7.125 | 700 | 0.1% |
| 7 | 1400 | 0.1% |
offering_year
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2015.8452 |
| Minimum | 2012 |
|---|---|
| Maximum | 2019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.2 MiB |
Quantile statistics
| Minimum | 2012 |
|---|---|
| 5-th percentile | 2012 |
| Q1 | 2014 |
| median | 2016 |
| Q3 | 2017 |
| 95-th percentile | 2019 |
| Maximum | 2019 |
| Range | 7 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.1006949 |
|---|---|
| Coefficient of variation (CV) | 0.0010420914 |
| Kurtosis | -0.93674086 |
| Mean | 2015.8452 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.2821349 |
| Sum | 2.6711965 × 109 |
| Variance | 4.4129189 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2017 | 252000 | |
| 2016 | 228200 | |
| 2018 | 173600 | |
| 2015 | 149800 | |
| 2019 | 147000 | |
| 2014 | 142800 | |
| 2013 | 116900 | |
| 2012 | 114800 |
| Value | Count | Frequency (%) |
| 2012 | 114800 | |
| 2013 | 116900 | |
| 2014 | 142800 | |
| 2015 | 149800 | |
| 2016 | 228200 | |
| 2017 | 252000 | |
| 2018 | 173600 | |
| 2019 | 147000 |
| Value | Count | Frequency (%) |
| 2019 | 147000 | |
| 2018 | 173600 | |
| 2017 | 252000 | |
| 2016 | 228200 | |
| 2015 | 149800 | |
| 2014 | 142800 | |
| 2013 | 116900 | |
| 2012 | 114800 |
offering_month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.3454834 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 11 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.3376678 |
|---|---|
| Coefficient of variation (CV) | 0.5259911 |
| Kurtosis | -1.2554025 |
| Mean | 6.3454834 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.036246801 |
| Sum | 8408400 |
| Variance | 11.140026 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11 | 151900 | |
| 3 | 151900 | |
| 5 | 147700 | |
| 9 | 142800 | |
| 2 | 129500 | |
| 8 | 115500 | |
| 6 | 102900 | |
| 1 | 84700 | |
| 7 | 84000 | |
| 10 | 81900 | |
| Other values (2) | 132300 |
| Value | Count | Frequency (%) |
| 1 | 84700 | |
| 2 | 129500 | |
| 3 | 151900 | |
| 4 | 77700 | |
| 5 | 147700 | |
| 6 | 102900 | |
| 7 | 84000 | |
| 8 | 115500 | |
| 9 | 142800 | |
| 10 | 81900 |
| Value | Count | Frequency (%) |
| 12 | 54600 | 4.1% |
| 11 | 151900 | |
| 10 | 81900 | |
| 9 | 142800 | |
| 8 | 115500 | |
| 7 | 84000 | |
| 6 | 102900 | |
| 5 | 147700 | |
| 4 | 77700 | |
| 3 | 151900 |
maturity_year
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2024.859 |
| Minimum | 2019 |
|---|---|
| Maximum | 2039 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.2 MiB |
Quantile statistics
| Minimum | 2019 |
|---|---|
| 5-th percentile | 2021 |
| Q1 | 2022 |
| median | 2024 |
| Q3 | 2027 |
| 95-th percentile | 2029 |
| Maximum | 2039 |
| Range | 20 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.42016 |
|---|---|
| Coefficient of variation (CV) | 0.0016890856 |
| Kurtosis | 3.3712725 |
| Mean | 2024.859 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 1.4922031 |
| Sum | 2.6831406 × 109 |
| Variance | 11.697495 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2023 | 194600 | |
| 2022 | 192500 | |
| 2024 | 180600 | |
| 2026 | 137900 | |
| 2027 | 123900 | |
| 2025 | 122500 | |
| 2021 | 91000 | |
| 2028 | 90300 | |
| 2029 | 72100 | 5.4% |
| 2020 | 51800 | 3.9% |
| Other values (11) | 67900 | 5.1% |
| Value | Count | Frequency (%) |
| 2019 | 4200 | 0.3% |
| 2020 | 51800 | 3.9% |
| 2021 | 91000 | |
| 2022 | 192500 | |
| 2023 | 194600 | |
| 2024 | 180600 | |
| 2025 | 122500 | |
| 2026 | 137900 | |
| 2027 | 123900 | |
| 2028 | 90300 |
| Value | Count | Frequency (%) |
| 2039 | 6300 | |
| 2038 | 11900 | |
| 2037 | 4900 | 0.4% |
| 2036 | 7700 | |
| 2035 | 12600 | |
| 2034 | 9800 | |
| 2033 | 2800 | 0.2% |
| 2032 | 700 | 0.1% |
| 2031 | 700 | 0.1% |
| 2030 | 6300 |
maturity_month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.1674591 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 20.2 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.3755852 |
|---|---|
| Coefficient of variation (CV) | 0.54732187 |
| Kurtosis | -1.1993941 |
| Mean | 6.1674591 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.18354206 |
| Sum | 8172500 |
| Variance | 11.394576 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 198100 | |
| 5 | 127400 | |
| 6 | 118300 | |
| 11 | 118300 | |
| 8 | 109200 | |
| 9 | 102900 | |
| 4 | 101500 | |
| 2 | 100800 | |
| 1 | 98000 | |
| 10 | 84700 | |
| Other values (2) | 165900 |
| Value | Count | Frequency (%) |
| 1 | 98000 | |
| 2 | 100800 | |
| 3 | 198100 | |
| 4 | 101500 | |
| 5 | 127400 | |
| 6 | 118300 | |
| 7 | 82600 | |
| 8 | 109200 | |
| 9 | 102900 | |
| 10 | 84700 |
| Value | Count | Frequency (%) |
| 12 | 83300 | |
| 11 | 118300 | |
| 10 | 84700 | |
| 9 | 102900 | |
| 8 | 109200 | |
| 7 | 82600 | |
| 6 | 118300 | |
| 5 | 127400 | |
| 4 | 101500 | |
| 3 | 198100 |
| entrd_vol_qt | rptd_pr | yld_pt | offering_amt | offering_price | offering_yield | coupon | offering_year | offering_month | maturity_year | maturity_month | principal_amt | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| entrd_vol_qt | 1.000 | -0.014 | 0.055 | 0.334 | 0.057 | 0.002 | 0.004 | 0.150 | -0.048 | 0.044 | -0.057 | 0.000 |
| rptd_pr | -0.014 | 1.000 | -0.506 | 0.103 | -0.055 | 0.344 | 0.350 | 0.143 | -0.058 | 0.411 | -0.023 | 0.008 |
| yld_pt | 0.055 | -0.506 | 1.000 | -0.166 | 0.003 | 0.366 | 0.365 | 0.087 | -0.000 | 0.245 | -0.010 | 0.000 |
| offering_amt | 0.334 | 0.103 | -0.166 | 1.000 | 0.095 | -0.179 | -0.174 | 0.119 | -0.097 | 0.006 | -0.101 | 0.041 |
| offering_price | 0.057 | -0.055 | 0.003 | 0.095 | 1.000 | -0.036 | -0.003 | 0.123 | -0.026 | -0.139 | -0.053 | 0.030 |
| offering_yield | 0.002 | 0.344 | 0.366 | -0.179 | -0.036 | 1.000 | 0.989 | 0.036 | -0.053 | 0.418 | -0.022 | 0.000 |
| coupon | 0.004 | 0.350 | 0.365 | -0.174 | -0.003 | 0.989 | 1.000 | 0.035 | -0.052 | 0.420 | -0.025 | 0.038 |
| offering_year | 0.150 | 0.143 | 0.087 | 0.119 | 0.123 | 0.036 | 0.035 | 1.000 | -0.191 | 0.489 | -0.166 | 0.067 |
| offering_month | -0.048 | -0.058 | -0.000 | -0.097 | -0.026 | -0.053 | -0.052 | -0.191 | 1.000 | -0.092 | 0.705 | 0.104 |
| maturity_year | 0.044 | 0.411 | 0.245 | 0.006 | -0.139 | 0.418 | 0.420 | 0.489 | -0.092 | 1.000 | -0.102 | 0.045 |
| maturity_month | -0.057 | -0.023 | -0.010 | -0.101 | -0.053 | -0.022 | -0.025 | -0.166 | 0.705 | -0.102 | 1.000 | 0.083 |
| principal_amt | 0.000 | 0.008 | 0.000 | 0.041 | 0.030 | 0.000 | 0.038 | 0.067 | 0.104 | 0.045 | 0.083 | 1.000 |
| cusip_id | trd_exctn_dt | bond_sym_id | company_symbol | entrd_vol_qt | rptd_pr | yld_pt | offering_amt | offering_price | offering_yield | principal_amt | coupon | offering_year | offering_month | maturity_year | maturity_month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 00037BAB8 | 2019-03-20 | ABB3852125 | ABB | 75000.0 | 99.96200 | 2.887133 | 1250000.0 | 97.833 | 3.12905 | 1000.0 | 2.875 | 2012 | 5 | 2022 | 5 |
| 1 | 00037BAB8 | 2019-03-21 | ABB3852125 | ABB | 1305000.0 | 100.36900 | 2.750151 | 1250000.0 | 97.833 | 3.12905 | 1000.0 | 2.875 | 2012 | 5 | 2022 | 5 |
| 2 | 00037BAB8 | 2019-03-22 | ABB3852125 | ABB | 1170000.0 | 100.30700 | 2.770905 | 1250000.0 | 97.833 | 3.12905 | 1000.0 | 2.875 | 2012 | 5 | 2022 | 5 |
| 3 | 00037BAB8 | 2019-03-25 | ABB3852125 | ABB | 600000.0 | 100.78626 | 2.609905 | 1250000.0 | 97.833 | 3.12905 | 1000.0 | 2.875 | 2012 | 5 | 2022 | 5 |
| 4 | 00037BAB8 | 2019-03-26 | ABB3852125 | ABB | 100000.0 | 100.66900 | 2.649010 | 1250000.0 | 97.833 | 3.12905 | 1000.0 | 2.875 | 2012 | 5 | 2022 | 5 |
| 5 | 00037BAB8 | 2019-03-27 | ABB3852125 | ABB | 100000.0 | 101.11000 | 2.501097 | 1250000.0 | 97.833 | 3.12905 | 1000.0 | 2.875 | 2012 | 5 | 2022 | 5 |
| 6 | 00037BAB8 | 2019-03-28 | ABB3852125 | ABB | 1535000.0 | 100.77700 | 2.612148 | 1250000.0 | 97.833 | 3.12905 | 1000.0 | 2.875 | 2012 | 5 | 2022 | 5 |
| 7 | 00037BAB8 | 2019-03-29 | ABB3852125 | ABB | 1459000.0 | 100.76800 | 2.614960 | 1250000.0 | 97.833 | 3.12905 | 1000.0 | 2.875 | 2012 | 5 | 2022 | 5 |
| 8 | 00037BAB8 | 2019-04-01 | ABB3852125 | ABB | 32000.0 | 100.50900 | 2.702067 | 1250000.0 | 97.833 | 3.12905 | 1000.0 | 2.875 | 2012 | 5 | 2022 | 5 |
| 9 | 00037BAB8 | 2019-04-02 | ABB3852125 | ABB | 360000.0 | 100.78400 | 2.609145 | 1250000.0 | 97.833 | 3.12905 | 1000.0 | 2.875 | 2012 | 5 | 2022 | 5 |
| cusip_id | trd_exctn_dt | bond_sym_id | company_symbol | entrd_vol_qt | rptd_pr | yld_pt | offering_amt | offering_price | offering_yield | principal_amt | coupon | offering_year | offering_month | maturity_year | maturity_month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1345390 | 98978VAN3 | 2022-08-18 | PFE4666688 | PFE | 50000.0 | 99.69000 | 3.958561 | 500000.0 | 99.811 | 3.92303 | 1000.0 | 3.9 | 2018 | 8 | 2028 | 8 |
| 1345391 | 98978VAN3 | 2022-08-22 | PFE4666688 | PFE | 29000.0 | 98.47800 | 4.189910 | 500000.0 | 99.811 | 3.92303 | 1000.0 | 3.9 | 2018 | 8 | 2028 | 8 |
| 1345392 | 98978VAN3 | 2022-08-23 | PFE4666688 | PFE | 200000.0 | 98.23900 | 4.236037 | 500000.0 | 99.811 | 3.92303 | 1000.0 | 3.9 | 2018 | 8 | 2028 | 8 |
| 1345393 | 98978VAN3 | 2022-08-24 | PFE4666688 | PFE | 1000000.0 | 98.56200 | 4.173956 | 500000.0 | 99.811 | 3.92303 | 1000.0 | 3.9 | 2018 | 8 | 2028 | 8 |
| 1345394 | 98978VAN3 | 2022-08-25 | PFE4666688 | PFE | 525000.0 | 98.39205 | 4.206974 | 500000.0 | 99.811 | 3.92303 | 1000.0 | 3.9 | 2018 | 8 | 2028 | 8 |
| 1345395 | 98978VAN3 | 2022-08-26 | PFE4666688 | PFE | 210000.0 | 98.38700 | 4.208056 | 500000.0 | 99.811 | 3.92303 | 1000.0 | 3.9 | 2018 | 8 | 2028 | 8 |
| 1345396 | 98978VAN3 | 2022-08-29 | PFE4666688 | PFE | 1500000.0 | 98.03600 | 4.276044 | 500000.0 | 99.811 | 3.92303 | 1000.0 | 3.9 | 2018 | 8 | 2028 | 8 |
| 1345397 | 98978VAN3 | 2022-08-30 | PFE4666688 | PFE | 125000.0 | 98.04100 | 4.275075 | 500000.0 | 99.811 | 3.92303 | 1000.0 | 3.9 | 2018 | 8 | 2028 | 8 |
| 1345398 | 98978VAN3 | 2022-08-31 | PFE4666688 | PFE | 480000.0 | 97.87200 | 4.308006 | 500000.0 | 99.811 | 3.92303 | 1000.0 | 3.9 | 2018 | 8 | 2028 | 8 |
| 1345399 | 98978VAN3 | 2022-09-01 | PFE4666688 | PFE | 400000.0 | 97.14800 | 4.450082 | 500000.0 | 99.811 | 3.92303 | 1000.0 | 3.9 | 2018 | 8 | 2028 | 8 |